Automatic workload driven index defragmentation
نویسندگان
چکیده
منابع مشابه
Automatic Workload Driven Index Defragmentation
Queries that scan a B-Tree index can suffer significant I/O performance degradation due to index fragmentation. The task of determining if an index should be defragmented is challenging for database administrators (DBAs) since today’s database engines offer no support for quantifying the impact of defragmenting an index on query I/O performance. Furthermore, DBMSs only support defragmentation a...
متن کاملAutomatic Workload Characterization
Workload characterization is an important and basic step for performance modeling and capacity planning. Traditional approaches for workload characterization often require sophisticated and time-consuming user assistance. In this paper we describe a number of algorithms for automatically classifying workloads and for determining what resources a workload used even when the operating system does...
متن کاملOn Workload-driven Router Designs
Over the past 15 years, the number of networks connected to the Internet, also called Autonomous Systems (ASes), grew at least by a factor of ten. Accordingly, estimations of the global IP tra c further emphasize this trend with a growth by four orders of magnitude. All this puts persistent pressure toward the core infrastructure of the Internet which is required to keep up with the increasing ...
متن کاملWorkload-driven adaptive log buffer-based FTL
Flash translation layer (FTL) is generally used for NAND flash memory in order to handle the mapping between logical page address and physical page address. Log buffer-based FTLs provide good performances with small-sized mapping information. In designing the log buffer-based FTL, one important factor is to determine the mapping architecture between data block and log block, called associativit...
متن کاملAutomatic Workload Management for Enterprise Data Warehouses
Modern enterprise data warehouses have complex workloads that are notoriously difficult to manage. Additionally, RDBMSs have many “knobs” for managing workloads efficiently. These knobs affect the performance of query workloads in complex interrelated ways and require expert manual attention to change. It often takes a long time for a performance expert to get enough experience with a large war...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Proceedings of the VLDB Endowment
سال: 2011
ISSN: 2150-8097
DOI: 10.14778/3402755.3402782